/* ---------------------------------------------------------------------- */
/* Script generated with: DeZign for Databases v4.1.3                     */
/* Target DBMS:           MS SQL Server 2005                              */
/* Project file:          De thi.dez                                      */
/* Project name:                                                          */
/* Author:                                                                */
/* Script type:           Database drop script                            */
/* Created on:            2011-04-29 14:26                                */
/* ---------------------------------------------------------------------- */


/* ---------------------------------------------------------------------- */
/* Drop foreign key constraints                                           */
/* ---------------------------------------------------------------------- */

ALTER TABLE [ThanhVien] DROP CONSTRAINT [ChucVu_ThanhVien]
GO

ALTER TABLE [ThanhVien] DROP CONSTRAINT [KhoaHoc_ThanhVien]
GO

ALTER TABLE [DangKyMonHoc] DROP CONSTRAINT [ThanhVien_DangKyMonHoc]
GO

ALTER TABLE [DangKyMonHoc] DROP CONSTRAINT [MonHoc_DangKyMonHoc]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "ChucVu"                                                    */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [ChucVu] DROP CONSTRAINT [PK_ChucVu]
GO

/* Drop table */

DROP TABLE [ChucVu]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "ThanhVien"                                                 */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [ThanhVien] DROP CONSTRAINT [PK_ThanhVien]
GO

/* Drop table */

DROP TABLE [ThanhVien]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "MonHoc"                                                    */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [MonHoc] DROP CONSTRAINT [PK_MonHoc]
GO

/* Drop table */

DROP TABLE [MonHoc]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "KhoaHoc"                                                   */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [KhoaHoc] DROP CONSTRAINT [PK_KhoaHoc]
GO

/* Drop table */

DROP TABLE [KhoaHoc]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "DangKyMonHoc"                                              */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [DangKyMonHoc] DROP CONSTRAINT [PK_DangKyMonHoc]
GO

/* Drop table */

DROP TABLE [DangKyMonHoc]
GO
